{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,8,17,15],[3,1,3,4],[4,1,4,4],[10,1,11,7],[16,1,18,6]]}
[]
[null,"Patient Warnings in Vision 3",null,null,null,null,null,null,"NOTE:"]
[null,null,null,null,null,null,null,null,"This will only work if Vision is on DLM485 or above."]
[null,"Registration Status",null,null,null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,"ACTIVE PATIENTS"]
[null,null,null,null,null,null,null,null,"Excel 2007 - Click the Options button and ENABLE both Macros and Data Connection"]
[null,null,null,null,null,null,null,null,"Excel 2003 - Not tested or approved for use with this version of Excel"]
[]
[null,null,null,null,null,null,null,null,"Last updated: 12/11/2018"]
[null,"When the data has been compiled in Excel",null,null,null,null,null,null,"Written by: Bradley Sieve"]
[null,"Messages with no text in them have been filtered out in the message column as they are no longer active",null,null,null,null,null,null,"Version: 2"]
[]
[null,null,null,null,null,null,null,null,"Disclaimer"]
[null,"v2.0",null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[null,"Now includes input operator"]
[]
[null,"v1.1 Now includes Registration Status and fix applied to message text extraction as some text was being cleared when in Excel"]
[]
[]
[]
[null,"There is also a utility that will bulk enter/remove patient warnings"]
[null,"at "]

{"sheet":"Lists","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["ACTIVE PATIENTS","REG000"]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]